Terix,

Hash is ok. Fine. Now... you have to update some other tables... but
as you are doing db changes by hand you have to be careful. You need
to:

1- Create the enty in liveuser_users for the new user (you already did it)

2- Create a new entry for the user in the permission users table:
liveuser_perm_users
Some like this:
INSERT INTO liveuser_perm_users VALUES (3, 3, 'DB', 1);

Where first value is a sequence, second one is the user id from
liveuser_users table, third and forth remain like above.

3- Create an entry in liveuser_groupusers table. There you relate
user to group (user type). Like this:
INSERT INTO liveuser_groupusers VALUES (3, 1);

Where first parameter is perm_user_id from liveuser_perm_users table
and second parameter is group_id from liveuser_groups table.

4. Now, as liveuser tables uses sequence tables, you must updated by
hand, otherwise you will be in trouble when creating new accounts.
Those tables are:

liveuser_users_auth_user_id_seq and liveuser_perm_users_perm_user_id_seq

5- Now is time to log into admin interface as admin user and
"Synchronize Campsite and Phorum users"

That is it, now your new user is a valid one and it can log into the system.

As you can see is kind of messy, so we highly recommend you to fix the
accounting management via admin UI.
I am wondering what's wrong with that, what kind of error message you
get when creating/editing an account?

Please take a look at the sequence tables and set proper values there.
Then try again creating an account.

Hope this helps.


On Wed, Apr 21, 2010 at 11:45 AM, wrote:
> Author: Terix
> Link:

Vote Up0Vote Down import April 2010

Posts: 0Member

Hi holman,

thank you a lot for your guide. I was able to make a new acocunt by hand as succesfully login with it. during the procedure i found that the user sequence was wrong (it was 20, when it had to be 6), then i've set it to 7 when i made the new account. Unfortunately, campsite is still blocking me from adding new users. the message that i get is "The user account could not be created." with no more details, and i'm going nuts to find what is going wrong. The weird thing is that the database works fine if i put it on another campsite installation (the one on my development server), so i doubt that it's a DB issue (but who ever knows). There is any way to get a more explicit error message? How can i pinpoint what is going wrong?